<?php
    $account = mysql_query("SELECT * FROM tblpharmacy WHERE email='".$_SESSION['username']."';");
    $account_t = mysql_fetch_array($account);
    $url = $account_t['shorturl'];
?>
<div class="box">
<div class="title">
Your Account
</div>
<ul class="sidemenu">
    <li><a href="<?php echo W_ROOT;?>/seller/">My Profile</a></li>
    <li><a href="<?php echo W_ROOT;?>/company/edit.php">Edit Your Tempate</a></li>
    <li><a href="<?php echo W_ROOT;?>/<?php echo $url;?>" target="_blank">View Your Page</a></li>
    <li><a href="<?php echo W_ROOT;?>/company/action/?p=edit_category">Change Category</a></li>
    <li><a href="<?php echo W_ROOT;?>/seller/product/">Product List</a></li>
    <li><a href="<?php echo W_ROOT;?>/seller/product/?view=add">Add New Product</a></li>
    <li><a href="<?php echo W_ROOT;?>/seller/editProductPrice.php">Edit Price</a></li>
    <li><a href="<?php echo W_ROOT;?>/seller/viewprescription.php">View Prescription</a></li> 
    <li><a href="<?php echo W_ROOT;?>/seller/selectAccountType.php">Update Your Account</a></li>
</ul>
</div>